Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting on cell with a formula
Hi! I'm having trouble with conditional formatting on cells in one sheet that
have formulas referring to another sheet. I have one sheet called "Worksheet". The user enters data in that sheet that is then transferred to another sheet called "Print Sheet". Say Print Sheet cell A1 has the formula "=IF(Worksheet!A60,Worksheet!A6,"")" The conditional formatting I want on Print Sheet is if Print Sheet cell A1 has the value from Worksheet A6 showing (in otherwords Worksheet A6 was 0) then Print Sheet cell A1 is to be colored gray. If the IF statement proved false and Print Sheet A1 shows blank or "", then Print Sheet A1 is to be conditionally formatted nothing. I tried the conditional formatting "cell value is" <0 and it still conditionally formatted the cell fill in gray because Print Sheet cell A1 does have a cell value... the IF statement formula... see what I mean? I also tried reference to sheet Worksheet cell A6, but Conditional Formatting doesn't like to look to other sheets. I even tried using this formuly [Staff Schedule.xls]Worksheet!$A$6 to help conditonal formatting deal with reference to another worksheet and it didn't like it. Can anyone help me with this? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is conditional formatting or formula possible by cell color? | Excel Worksheet Functions | |||
Recognizing Cell Formatting To Use In A Formula Or Conditional For | Excel Worksheet Functions | |||
Conditional formatting formula that uses VLookup, based on content of another cell | Excel Discussion (Misc queries) | |||
Conditional formatting formula that uses VLookup, based on content of another cell | Excel Discussion (Misc queries) | |||
Conditional Formatting if cell content is a formula | Excel Worksheet Functions |