If a formula, conditional format

Joe Carter

New Member
Joined
Nov 26, 2019
Messages
15
Office Version
  1. 365
Platform
  1. Windows
I've created a manpower worksheet. In the cell for each week I have a simple formula =total hours/# of weeks. So I know the average # of hours per week - works just fine.

I will be over-riding the formula and typing in hours I think that discipline will be working on the job for the next few weeks. I want to know if I've typed over the formula or not using conditional formatting.

Typical formula is =IF($J5<CP$3,0,$E5/$H5), if the end date is less that the active week's date, then 0, else divide total hours by total weeks.

I've tried
"format only cells that contain" - "specific text" - "beginning with" - "=". doesn't work.
"format only cells that contain" - "specific text" - "containing" - "$". doesn't work.

Any help would be greatly appreciated. There's got to be something simple I'm not seeing.

Joe
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
10,783
Try this CF formula:

=ISTEXT(FORMULATEXT(A1))

or the other way:

=ISERROR(FORMULATEXT(A1))*(A1<>"")
 
Solution

Joe Carter

New Member
Joined
Nov 26, 2019
Messages
15
Office Version
  1. 365
Platform
  1. Windows
Rule Type: "Use a formula to determine which cells to format"
Format values where this formula is true: "=ISTEXT(FORMULATEXT(CS6))"
Where "CS6" is the cell with the conditional format. Then I copied the cell throughout the spreadsheet.
 

Watch MrExcel Video

Forum statistics

Threads
1,128,157
Messages
5,629,023
Members
416,359
Latest member
Juena

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top