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.