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
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies