Home

Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-469430%22%20slang%3D%22en-US%22%3EConditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-469430%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20check%20the%20font%20colour%20on%20a%20range%20of%20cells.%20If%20any%20one%20of%20the%20range%20of%20cells%20has%20a%20red%20font%20colour%20then%20I%20need%20a%20formula%20to%20return%20a%20true%20value%20or%20false%20value%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20can%20you%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-469430%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-473343%22%20slang%3D%22en-US%22%3ERE%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-473343%22%20slang%3D%22en-US%22%3EHi%2C%20Do%20the%20cells%20actually%20have%20the%20font%20color%20to%20red%20or%20is%20conditional%20formatting%20causing%20them%20to%20display%20that%20way%3F%20(Wondering%20because%20of%20your%20title).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-473675%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-473675%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20and%20thanks%20for%20getting%20back%20to%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20contents%20of%20the%20cells%20B10%3BQ10%20are%20conditionally%20set%20to%20red%20with%20the%20following%20formula%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DAND(B10%20%26gt%3B%200%2CB11%20%3D%200)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20need%20to%20do%20is%20check%20if%20any%20of%20say%20row%20B10%3BQ10%20are%20red%20on%20Sheet1.%20If%20so%20then%20I%20need%20to%20set%20the%20contents%20of%20a%20cell%20on%20another%20worksheet%20(sheet2)%20to%20red%20to%20indicate%20that%20there%20is%20an%20issue%20on%20the%20other%20worksheet%20(Sheet1).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F253376%22%20target%3D%22_blank%22%3E%40JWR1138%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
vonryan
Contributor

Hi All,

 

I am trying to check the font colour on a range of cells. If any one of the range of cells has a red font colour then I need a formula to return a true value or false value

 

Please can you help.

2 Replies
Hi, Do the cells actually have the font color to red or is conditional formatting causing them to display that way? (Wondering because of your title).

Hello and thanks for getting back to me.

 

The contents of the cells B10;Q10 are conditionally set to red with the following formula

 

=AND(B10 > 0,B11 = 0)

 

What I need to do is check if any of say row B10;Q10 are red on Sheet1. If so then I need to set the contents of a cell on another worksheet (sheet2) to red to indicate that there is an issue on the other worksheet (Sheet1).

 

Thanks for your help

 

@JWR1138 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies