I am trying to make a budget spreadsheet. I want the cell to change color to red if the entered currency is greater than a reference cell. This is what I have but nothing changes. I also need the standard currency format to apply.
[red][>b16]$##,###.##;[black]$##,###.##
Hello @mcfarlane,
You could do this with “Conditional Formatting” as follows:
“Format : Conditional Formatting : Condition...”;Instead of the “Bad” style, you could also add your own style by selecting the item “New Style…” in the listbox “Apply Style:”.
HTH, lib
Thank you it worked. Is there a way to apply to several cells for same reference cell? Just to be more efficient. I tried highlighting and copying but would reference cell in front of current working cell.
You’re welcome @mcfarlane :),
To apply the conditional formatting to several cells at once, just select all the cells and proceed from step 2.
Alternatively you could specify the cell range address, below in the Conditional Formatting dialog in the textbox called Range: , e.g. for cells C1 to C5, you would enter C1:C5 there.
To accept the above answer as correct, please click on the checkmark icon on the left, and karma-permitting upvote it 
I tried that, the first cell works but all the rest dont. Any thoughts? My first condition was to turn cell red if greater than reference cell. The rest of the cells turn red no matter what value is put in. My second condition wa’s to default if less than or equal to reference cell as you ssid.
Please check if there are older (overlapping) formatting rules in the menu Format : Conditional Formatting : Manage..., and if so, delete them.
If the problem persists, then please upload a sample document ( after removing all sensitive data from it ), by editing your original question and clicking the paperclip button there.