Forum Discussion
Conditional Formatting/Formula Help
Hi all I'm a novice when it comes to excel and was hoping for some help with conditional formatting and creating a formula. I have 3 sheets with similar layouts but different rows need to 'greyed...
https://1drv.ms/x/c/929542c936bbf740/EY6jO_RboWVPtwWMUxLkY20B5gL6Jy8rWe1jtOAUjU_GCg?e=bRQ2Mc
Hope this works
Hope this works
I have received your PM.
Select the range from C5 to the lower right corner of the used range - its location depends on the sheet.
C5 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=OR($B5=530000,$B5=540000,$B5=610000,$B5=620000,$B5=710000,$B5=720000)
Click Format...
Activate the Fill tab.
Select the desired background color.
If you wish you can also select a text color on the Font tab.
Click OK, then click OK again.