Forum Discussion

Iron Contributor

Mar 03, 2022

Conditional formatting in visible cells

Hello Everyone,

I want to apply conditional formatting in visible cells which is Mark red greater than $6000

like -

Please help ..

Here is a attached file..

Book4.xlsx12 KB

Formulas and Functions

4 Replies

NikolinoDE
Platinum Contributor
Mar 03, 2022
Excel
Conditional formatting => New rule => Formula for determining...
=$E$9>6000
Book4.xlsx11 KB
- Excel
  Iron Contributor
  Mar 03, 2022
  Thank you so much sir..
Riny_van_Eekelen
Platinum Contributor
Mar 03, 2022
Excel Why not just apply the rule to the entire range. It will highlight ALL values greater than 6000. Collapse the outline and the rule will still apply.
- Excel
  Iron Contributor
  Mar 03, 2022
  Thank you so much sir.

Resources