Ask Your Question
0

Conditional Formating For Multiple Sheets Multiple Cells [closed]

asked 2012-12-08 15:30:47 +0100

hunter99507 gravatar image

updated 2015-10-21 04:36:51 +0100

Alex Kemp gravatar image

In my spreadsheet I have 12 sheets (jan,feb,march, ect) I used to be able to edit all 12 of those sheets at once by using ctrl + clicking each sheet. So for example if i wanted to add "2012" in A1 in all 12 sheets i would use ctrl to select all 12 sheets, then i would edit A1 with "2012", then press enter. After i pressed enter it would change ALL 12 sheets in cell A1. I want to do this with "Conditional Formatting"

I cant seem to make it work with the latest version. Any suggestions? Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 04:37:03.930277

Comments

This is a result of the new range based conditional formats and will not be fixed. Conditional formats are now a sheet property and no longer a cell style property.

moggi gravatar imagemoggi ( 2012-12-10 16:38:17 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2013-02-04 03:50:09 +0100

qubit gravatar image

(Turning comment into answer so we can resolve this question)

@moggi write:

This is a result of the new range based conditional formats and will not be fixed. Conditional formats are now a sheet property and no longer a cell style property.

edit flag offensive delete link more
0

answered 2012-12-08 22:21:44 +0100

m.a.riosv gravatar image
edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-12-08 15:30:47 +0100

Seen: 766 times

Last updated: Feb 04 '13