Forum Discussion

Copper Contributor

Sep 29, 2023

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...

excel

Formulas and Functions

HansVogelaar

MVP

Sep 29, 2023

dazgroves

We cannot see your local hard disk...

Please upload your workbook to OneDrive, Google Drive or Dropbox, share it and paste a link to the uploaded file in a reply.

dazgroves

Copper Contributor

Oct 01, 2023

https://1drv.ms/x/c/929542c936bbf740/EY6jO_RboWVPtwWMUxLkY20B5gL6Jy8rWe1jtOAUjU_GCg?e=bRQ2Mc

Hope this works

HansVogelaar
MVP
Oct 01, 2023
dazgroves

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.
HansVogelaar
MVP
Oct 01, 2023
dazgroves

I get "Sorry, an error has occurred".

If you wish, you can send me a private message (click on my user picture) and attach the workbook to the message.