Hi,
A quick question on conditional formatting. I defined a conditional formatting on a cell. How can I copy and paste the conditional formatting on other cells.
Thanks,
nevada15
Hi,
A quick question on conditional formatting. I defined a conditional formatting on a cell. How can I copy and paste the conditional formatting on other cells.
Thanks,
nevada15
Copy the cell and Paste Specials (formats), or change the appliedrange for the CF.
Oh, great! It worked now. Thanks!
nevada15
The paintbrush icon is quicker.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi all,
I have a column with values and I would like for conditional formatting to highlight just one cell with the lowest value
from the entire column of values. Could you please give me an idea of the formula to accomplish this? The column with
the values is pasted below here:
07:27
07:12
06:19
08:12
06:27
05:57
07:57
04:35
09:08
07:39
06:02
05:33
06:13
08:04
05:15
05:17
06:53
06:45
08:22
use top bottom rule in conditional formatting and change bottom to 1
Hi all, I have a row of cells that I would like to have the first cell in the row be colored based on the value of the last cell.
The value happens to be times (minutes:seconds)
I would like the first cell in the row to be colored red if the value of the last cell in the row is equal to or greater than 7:00
I would like the first cell in the row to be colored yellow if the value of the last cell in the row is less than 7:00
The row with the cells is below:
BRISTO A NOT GOOD Fast Track drive thru average 07:00
Any ideas?
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks